# DROP DATABASE MYSTUDY;
# CREATE DATABASE MYSTUDY;
# USE MYSTUDY;
# DROP TABLE STUDENT;
# CREATE TABLE STUDENT(
# NAME VARCHAR(10),
# AGE INT,
# STUNO CHAR(10),
# GENDER ENUM('男','女'),
# COLLEGE VARCHAR(50),
# GRADE VARCHAR(10),
# PRIMARY KEY (STUNO)
# );
# INSERT INTO STUDENT VALUES('小明','18','000001','男','计算机学院','大一');
# INSERT INTO STUDENT VALUES('小红','18','000002','女','法学院','大一');
# INSERT INTO STUDENT VALUES('小张','18','000003','男','财会学院','大一');
# INSERT INTO STUDENT VALUES('小王','18','000004','男','计算机学院','大一');
# INSERT INTO STUDENT VALUES('大壮','19','000005','男','体育学院','大一');
# INSERT INTO STUDENT VALUES('小美','19','000006','女','法学院','大一');
# INSERT INTO STUDENT VALUES('小卡拉米','19','000007','男','财会学院','大一');
# INSERT INTO STUDENT VALUES('大壮','19','000008','男','体育学院','大二');
# INSERT INTO STUDENT VALUES('张丽','19','000009','女','计算机学院','大二');
# INSERT INTO STUDENT VALUES('小黑','19','000010','男','计算机学院','大二');
# INSERT INTO STUDENT VALUES('张三','19','000011','男','财会学院','大一');
# INSERT INTO STUDENT VALUES('李四','20','000012','男','体育学院','大二');
# INSERT INTO STUDENT VALUES('王五','20','000013','男','法学院','大三');
# INSERT INTO STUDENT VALUES('赵六','20','000014','男','体育学院','大三');
# INSERT INTO STUDENT VALUES('小青','19','000015','男','体育学院','大一');
# INSERT INTO STUDENT VALUES('坤坤','20','000016','男','计算机学院','大一');
# INSERT INTO STUDENT VALUES('鸽鸽','21','000017','男','计算机学院','大四');